UPDATE [SVWASTMS].[dbo].[TM_TMS_POTYPE] SET IS_CALC_YJDHTIME = 1 WHERE	PO_TYPE IN ( 'A', 'T' )
GO

-- 首先，添加 PSJP_REQUIREPICKTIME 字段
ALTER TABLE dbo.TT_TMS_PURCHASEORDERROW ADD PSJP_REQUIREPICKTIME DATETIME;
GO

-- 然后，为 PSJP_REQUIREPICKTIME 字段添加描述
EXEC sp_addextendedproperty 
    @name = N'MS_Description', 
    @value = N'要求拣配完成时间', 
    @level0type = N'Schema', @level0name = 'dbo',  -- 根据实际的 schema 名称修改
    @level1type = N'Table',  @level1name = 'TT_TMS_PURCHASEORDERROW',
    @level2type = N'Column', @level2name = 'PSJP_REQUIREPICKTIME';
GO
